package com.java.al.string;

public class PrintOutString {
	public static void main(String[] args) {
		String str = "	select   cont.reserve_no,cust_name, cont.contract_id, cont.cust_id, car.type_id car_type_id	,			" +
		"	to_char(start_time_p,'yyyy-mm-dd hh24:mi') start_time_p, 			" +
		"	to_char(end_time_p,'yyyy-mm-dd hh24:mi') end_time_p,   			cust.card_no, 			" +
		"	call_user_id,card.catd_type,cat.type_name card_type,							" +
		"	cat.type_id card_type_id,dis.discount_id , s_shop_id, s_shop.shop_name s_shop_name,			" +
		"	s_address, 	d_shop_id, 	d_shop.shop_name t_shop_name,			d_address, helper_id,   			" +
		"	mobile  ,		assure_name, assure_id, assure_add, 		assure_post, assure_phone,					" +
		"	assure_company,assure_companyadd,				urgent_name, urgent_phone,cust.scor, e_num ,			" +
		"	dis.act_name,ccar.car_id	,car.license_no,helper.shop_name	" +
		
		"	from tba_cust cust left join  tda_custcard card on cust.card_no = card.card_no	" +
		"	left join catalog cat on card.catd_type = cat.type_id and cat.catalog_id = 23,	" +
		"	tra_cont2car ccar,tca_car car ,tra_contract cont 					" +
		"	left join tma_city2discount dis on 		cont.discount_id = dis.discount_id 	" +
		"	left join tma_shop helper on cont.helper_id = helper.shop_id		" +
		"	left join tma_shop s_shop on cont.s_shop_id = s_shop.shop_id	" +
		"	left join tma_shop d_shop on cont.d_shop_id = d_shop.shop_id	" +
		
		"	where cont.cust_id = cust.cust_id " +
		"	and cont.contract_id = ccar.contract_id	and 	ccar.car_id = car.car_id			" +
/*
*   只有提车时 user_id 才会被填入  
*   contract_stat 合同状态 	0 - 未取消	 
*/
		"	and cont.contract_stat  = 0 	" +
		"	and cont.user_id is  null 		and		" +
		"	cont.cust_id = ";

		System.out.println( str );
	}
}
